﻿CREATE PROCEDURE [dbo].[proc_MarketProject_Create](
	@T1 INT,
	@T2 INT,
	@BeginDate DATETIME,
	@EndDate DATETIME,
	@CityAddress NVARCHAR(100),
	@BorrowingAmount DECIMAL(18,2),
	@Account DECIMAL(18,2),
	@Profits DECIMAL(18,2),
	@CreateDate DATETIME,
	@EditDate DATETIME,
	@flag INT,
	@USERID VARCHAR(50),
	@DWBH INT,
	@BMBH VARCHAR(50)
)
AS
BEGIN

INSERT INTO [MarketProject]
           ([T1]
           ,[T2]
           ,[BeginDate]
           ,[EndDate]
           ,[CityAddress]
           ,[BorrowingAmount]
           ,[Account]
           ,[Profits]
           ,[CreateDate]
           ,[EditDate]
           ,[flag]
           ,[USERID]
           ,[DWBH]
           ,[BMBH])
     VALUES
           (
           @T1,
           @T2,
           @BeginDate,
           @EndDate,
           @CityAddress,
           @BorrowingAmount,
           @Account,
           @Profits,
           @CreateDate,
           @EditDate,
           @flag,
           @USERID,
           @DWBH,
           @BMBH
           )



	SET NOCOUNT ON;
SELECT @@IDENTITY
END
